package com.woniuxy.daos;

import com.woniuxy.entitys.Company;
import com.woniuxy.entitys.Service;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface ServiceDao {

    int deleteByPrimaryKey(Integer svr_id);


    int insert(Service record);

    int insertSelective(Service record);

    Service selectByPrimaryKey(Integer svr_id);

    int updateByPrimaryKeySelective(Service record);

    int updateByPrimaryKey(Service record);
    //查询需要修改服务
    public List<Service> selectAllService(String key, String value);
    //查询归档信息
    public List<Service> selectAll();
    //创建服务
    public Integer saveService(Service service);

    List<Company> selectByComName(@Param("name") String name);


    int upddue(Integer id);

    //根据年份和客户id分组查询
    List<Map<String, Object>> getServeCount(String year, Integer com_id);
}